home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Night Owl 6
/
Night Owl's Shareware - PDSI-006 - Night Owl Corp (1990).iso
/
023a
/
cbase.zip
/
MANUAL.DOC
< prev
Wrap
Text File
|
1986-12-21
|
65KB
|
1,548 lines
______________________________________________________________________
| |
| CBASE |
| Version 1.1A |
| Copyright (C) 1985,1986 |
| By |
| PC Software Services |
|____________________________________________________________________|
USERS GUIDE
-----------
CBASE Version 1.1A Copyright (C) 1985,1986 PC Software Services Page i
TABLE OF CONTENTS
_________________
General Information .............................................. 1
Registration Information ..................................... 1
Technical Contact ............................................ 1
File Descriptions ............................................ 1
Changes from Release 1.0 ..................................... 2
Things You Should Know Before Starting ........................... 3
CONFIG.SYS ................................................... 3
File Placement ............................................... 3
Data Base Backup ... (PLEASE READ THIS !!!) .................. 3
Data Base Format ................................................. 4
Field Sizes and Contents ..................................... 4
Keyboard Keys Recognized By CBASE ................................ 5
Getting Started .................................................. 7
Creating A Data Base ......................................... 7
Overview Of CBASE Functions ...................................... 8
Adding Records ............................................... 9
Tips ..................................................... 10
DOS Commands ................................................. 11
Select/Create A Data Base .................................... 12
Find A Record ................................................ 13
Print A Label/Envelope ................................... 14
Moving Through The Data Base ............................. 14
Edit ..................................................... 15
Delete ................................................... 16
List/Print The Data Base ..................................... 17
Print To Labels .......................................... 18
Print To Paper ........................................... 19
List To Screen ........................................... 20
Options ...................................................... 21
Color Options ............................................ 22
Other Options ............................................ 23
Supply Today's Date On Add Screen ..................... 23
Constantly Update Time/Date on Screen ................. 23
Sound Beep With Error Messages ........................ 23
Eliminate Snow With IBM Color Card .................... 23
Printer Options .......................................... 24
Lines Per Page ........................................ 24
Lines Per Label ....................................... 24
Spaces To Indent For Labels ........................... 24
Labels Across ......................................... 24
Spaces Per Label ...................................... 24
Utilities .................................................... 25
Backup Data Base ......................................... 25
Display Data Base Info ................................... 26
Rebuild Index Files ...................................... 26
Restore Data Base ........................................ 27
Refresh The Screen ....................................... 27
Error Recovery ................................................... 28
Notes From The Author ............................................ 30
CBASE Version 1.1A Copyright (C) 1985,1986 PC Software Services Page 1
CBASE Version 1.1A Copyright (C) 1985,1986 By PC Software Services
__________________________________________________________________
CBASE is distributed using the "Shareware" concept. This allows
potential users to try a product before buying it. If you like CBASE,
a contribution ($15 suggested) will help us to continue writing and
and supporting quality software. When you register please include
your name, address, CBASE version, and optionally what you plan to use
CBASE for. In addition, we invite your suggestions for changes and
and additions to CBASE. Several of the features currently in CBASE
come directly from suggestions provided by users.
Your registration will provide you with new releases for the cost of
postage and handling, and new versions for a reduced price.
Note: Please add $7 if you would like a printed copy of this document.
LIABILITY FOR USE OF CBASE IS LIMITED
TO THE REGISTRATION PRICE OF CBASE
TO REGISTER, send the above information and your donation
To:
PC Software Services
P.O. Box 22661
Houston Texas, 77227-2661
FOR TECHNICAL INFORMATION, contact:
PC Software Services
Same Address
or call:
(713) 931-0507
Files contained on this disk include:
CBASE.COM - The CBASE program library
CBASE.000 - The CBASE overlay (must reside in set drive/directory)
CBASE-RD.ME - File Descriptions
CBASE11A.DOC - User's Guide (This is it) <== PRINT THIS
CBASESMP.DAT - Sample Data Base data file
CBASESMP.IXC - Sample Data Base customer number index file
CBASESMP.IXN - Sample Data Base customer name index file
CONFIG.SYS - Put this in the Root Directory of the disk used
to Boot DOS if you don't already have one. This
allows more than 5 files to be opened.
The following files will be created when the program is first run:
CBASE11.PRM - The CBASE parameter file
CBASESMP.BAK - Sample Data Base backup (if CBASESMP is used)
The disk may also include:
CBASECVT.COM - A program to convert CBASE 1.0 data base to 1.1A
CBASECVT.000 - Overlay file for CBASECVT.COM
CBASE Version 1.1A Copyright (C) 1985,1986 PC Software Services Page 2
Changes And New Functions In CBASE 1.1A
---------------------------------------
1. The format of the data base was changed to add support for the attn
field in the record and to separate the Zip Code from the City
and State field. This attn field allows the user to optionally
have the customer name appear at the bottom of the label preceded
by ATTN:. To prevent increasing the size of the data base, the
date field was reduced from 20 to 18 characters. A program called
CBASECVT is available to convert CBASE 1.0 data bases to CBASE 1.1A
format.
2. Corrected problem where message "Invalid Key Pressed" would appear
after printing an alignment label.
3. Reversed the function of "Up Arrow/Pg Up" And "Down Arrow/Pg Dn" in
the Find/Display function. By VERY popular demand, the first now
means PREV record and the second now means NEXT record. Thanks for
the overwhelming feedback on this one!
4. When printing labels, if no company name exists, customer name will
be moved to the second line. This prevents the blank line showing
on the label.
5. Added support for user control of where the backup data base is to
be placed. Via the data base selection panel, the user may now
specify the drive and directory for the backup data base.
6. Added full function scrolling and select support to the list to
screen option. This is a complete replacement for the list to
screen option. See the section describing this function for
a complete description.
7. The color options support was enhanced to allow specification of
the foreground and background colors for three fields.
8. Enhanced the screen appearance.
9. Added support for 2, 3, or 4 labels across.
10. Added support for a DOS command entry option ("C").
Changes Coming In CBASE 1.2A
----------------------------
1. Improved error recovery for data base access. CBASE 1.2A will
allow by option the capability to attempt a retry. This will
be only for errors such as "Drive Not Ready" and not for
"Disk Full" or other errors which are impossible to retry.
2. Add a Report Generator option. This option will allow you to
determine which fields will be printed and where on the page.
Thanks to Tim Hanes of Asyst Inc. for this suggestion.
******************************************************************
*** Most of the enhancements added to CBASE come directly from ***
*** CBASE users. If you would like to see something added or ***
*** improved in CBASE, let us know. We want CBASE to be ***
*** everything YOU want! ***
******************************************************************
CBASE Version 1.1A Copyright (C) 1985,1986 PC Software Services Page 3
THINGS YOU SHOULD KNOW BEFORE STARTING
--------------------------------------
CONFIG.SYS:
This file should be placed in the root directory of the disk used to
boot up DOS. If you already have a CONFIG.SYS file, please make sure
that it has a line stating "FILES=" with a quantity of 10 or more. Call
us if you need help with this.
File Placement:
The location of files is important to CBASE. The following files should
be located on the default drive and directory at the time that CBASE is
run:
CBASE.COM - The CBASE Program.
CBASE.000 - The CBASE Overlay File.
CBASE11.PRM - The CBASE Parameter File.
(Will be created for you)
The second two files above are referenced by CBASE during program
execution with the assumption that they reside on the default drive and
directory. It is a good idea to put the documentation files in the same
place as the above files.
The only restriction with the data base files is that the four primary
files associated with each data base be stored in the same drive and
directory. You are allowed to select the location of these files at
data base creation time. With this release of CBASE (1.1A), the backup
file may now be directed to a different drive and directory from the
main data base files. At data base creation time, you are prompted for
a data base name (1 to 8 Characters). The name of the sample data base
is CBASESMP. The data base files associated with CBASESMP are:
CBASESMP.DAT - Contains the actual data
CBASESMP.IXC - Customer code index
CBASESMP.IXN - Customer name index
CBASESMP.IXZ - Customer zip code index
CBASESMP.BAK - Backup of CBASESMP.DAT with backup info
DON'T USE THE ORIGINAL COPY OF CBASE; MAKE A COPY AND USE IT.
Data Base Backup: <<<< PLEASE READ THIS !!! >>>>
This is the most important function of CBASE. After spending a lot of
time entering data into the data base, it is important to protect that
data. CBASE provides utilities to aid in this effort. The Backup
function will back up the data portion of your data base. If your data
base name is CUST then the backup file will be: CUST.BAK. The only
difference between the data base data file and the backup file is an
added record to the backup file containing the date and time of the last
backup. YOUR BACKUP FILE SHOULD BE DIRECTED (VIA THE DATA BASE
SELECTION SCREEN) TO A SEPARATE DRIVE (OR AT LEAST A DIFFERENT
DIRECTORY) FROM THE MAIN DATA BASE FILES. If you have a good copy
of the data portion of the data base, the index can be rebuilt with the
rebuild index function.
CBASE Version 1.1A Copyright (C) 1985,1986 PC Software Services Page 4
DATA BASE FORMAT
----------------
_____________________________________________________________________________
| PC Software Services CBASE 1.1A August 26, 1985 02:05pm |
|___________________________________________________________________________|
Add Records Entry Panel
Cust. Code ===> _____(15)______ Date ===> ________(18)________
Last Name ===> _____(15)______ First Name ===> ___(10)___
Company ===> _______________(40)_____________________
Address ===> _______________(40)_____________________
===> __________(30)____________ Zip ===> ___(10)___
Bus. Phone ===> ________(20)________ Home Phone ===> ______(15)_____
Comments ===> ___________________(50)___________________________
Name = ATTN: ===> (1)_
Press "F10"-SAVE "Esc"-LEAVE
_____________________________________________________________________________
| Messages: |
|___________________________________________________________________________|
Data Base : CBASESMP Records : 25 Current Record # : 1
This is the screen you will see when you enter the ADD function of
CBASE. The entry fields above show you what may be put into the data
base.
The data base has three keys: The Customer Number, a combination of the
Last and First Name, and the Zip Code.
The Customer Number field will be converted to upper case as you enter
it. This field must be unique throughout the entire data base. CBASE
will give an error message if an attempt is made to add a duplicate
customer number.
The Last and First Name fields may be entered in upper or lower case and
may be duplicated as necessary. When a search is done by Last and First
Name, the upper case of the search name is compared with the upper case
of the names in the data base.
The Zip Code field may be entered in upper or lower case and may be
duplicated as necessary. When a search is done by Zip Code, the upper
case of the search name is compared with the upper case of the Zip Code.
The other fields may be entered in upper or lower case and be duplicated
as necessary.
The maximum allowed length of each field is shown in parentheses.
CBASE Version 1.1A Copyright (C) 1985,1986 PC Software Services Page 5
KEYS RECOGNIZED BY CBASE
------------------------
KEY ACTION FUNCTIONS
--- ------ ---------
"F1" HELP (Not Supported Until Version 2) All Screens
"F2" EDIT RECORD Find Display Screen
List To Screen Opt.
"F3" DELETE RECORD Find Display Screen
List To Screen Opt.
"F4" PRINT A LABEL Find Display Screen
List To Screen Opt.
"F6" ERASE TO END OF FIELD Data Entry Panels
"F9" RETURN TO MAIN MENU All Menu Screens +
"F10" ENTER Data Entry Panels
"Esc" LEAVE or ABORT CURRENT FUNCTION All Screens
"Enter" POSITIVE RESPONSE TO VERIFY Verify Panels
MOVE TO NEXT ENTRY FIELD Data Entry Panels
"Home" DISPLAY FIRST RECORD OF SELECTED KEY Find Display Screen
SCROLL TO TOP OF DATA BASE List To Screen Opt.
MOVE TO BEGINNING OF DATA FIELD Data Entry Panels
"End" DISPLAY LAST RECORD OF SELECTED KEY Find Display Screen
SCROLL TO BOTTOM OF DATA BASE List To Screen Opt.
MOVE TO END OF DATA FIELD Data Entry Panels
"Ctrl End" ERASE TO END OF FIELD Data Entry Panels
CBASE Version 1.1A Copyright (C) 1985,1986 PC Software Services Page 6
KEYS RECOGNIZED BY CBASE
------------------------
KEY ACTION FUNCTIONS
--- ------ ---------
"-->|" MOVE TO NEXT ENTRY FIELD Data Entry Panels
"|<--" MOVE TO PREVIOUS ENTRY FIELD Data Entry Panels
"<--"(Bkspc) ERASE AND MOVE TO PREVIOUS CHARACTER Data Entry Panels
"-->" MOVE TO NEXT CHARACTER Data Entry Panels
"<--" MOVE TO PREVIOUS CHARACTER Data Entry Panels
"Ins" GO INTO INSERT MODE Data Entry Panels
"Del" DELETE CHARACTER Data Entry Panels
"Up Arrow" DISPLAY PREVIOUS RECORD-SELECTED KEY Find Display Screen
MOVE POINTER UP 1 RECORD ON SCREEN List To Screen Opt.
MOVE TO ENTRY FIELD DIRECTLY ABOVE Data Entry Panels
"Pg Up" DISPLAY PREVIOUS RECORD-SELECTED KEY Find Display Screen
MOVE POINTER UP 1 PAGE ON SCREEN List To Screen Opt.
"Dn Arrow" DISPLAY PREV RECORD-SELECTED KEY Find Display Screen
MOVE POINTER DOWN 1 RECORD ON SCREEN List To Screen Opt.
MOVE TO ENTRY FIELD DIRECTLY BELOW Data Entry Panels
"Pg Dn" DISPLAY NEXT RECORD-SELECTED KEY Find Display Screen
MOVE POINTER DOWN 1 PAGE ON SCREEN List To Screen Opt.
CBASE Version 1.1A Copyright (C) 1985,1986 PC Software Services Page 7
GETTING STARTED
---------------
_____________________________________________________________________________
| PC Software Services CBASE 1.1A August 26, 1985 02:05pm |
|___________________________________________________________________________|
DATA BASE Entry Panel
Data Base Drive ===> _ (Ex: C)
Data Base Directory ===> _______________(35)________________ (Ex: \PCDBASE\)
Name of Data Base ===> __(8)___ (Ex: BANKCUST)
Bkup Base Drive ===> _ (Ex: B)
Bkup Base Directory ===> _______________(35)________________ (Ex: \PCBKUP\)
Press "F10"-ENTER "Esc"-ABORT
_____________________________________________________________________________
| Messages: |
|___________________________________________________________________________|
Data Base : Records : 0 Current Record # : 1
This is the first screen you will see after the intro screen. If this
is the first time CBASE is executed, no parameter file will have been
created. In this case the drive and directory will be defaulted to the
current drive and directory and the data base will be defaulted to the
sample data base: CBASESMP.
If a parameter file exists, the information will be filled in with the
data base info from the last execution of CBASE.
Once the information has been filled in, Press "F10" to ENTER. If the
data base exists, it will be opened and the MAIN Selection Menu will be
displayed. If the data base does not exist, you will be prompted for
permission to create the data base or restore the data base if a backup
was found.
If an error occurs opening the index files or the index files do not
exist, they will automatically be rebuilt.
If no data base is open and the response to the above screen is "Esc",
the CBASE program will be terminated.
CBASE Version 1.1A Copyright (C) 1985,1986 PC Software Services Page 8
CBASE FUNCTIONS
---------------
_____________________________________________________________________________
| PC Software Services CBASE 1.1A August 26, 1985 02:05pm |
|___________________________________________________________________________|
MAIN Selection Menu
A - Add Records
C - DOS Commands
D - Select/Create A Data Base
F - Find..Edit/Delete A Record
L - List/Print Data Base
O - Options
U - Utilities
Esc - Leave CBASE
_____________________________________________________________________________
| Messages: |
|___________________________________________________________________________|
Data Base : CBASESMP Records : 25 Current Record # : 1
This is the main selection menu. As with all of the menu screens, all
that is necessary to select an option is to type the letter preceding
the option desired.
Pressing "F9" from any other Menu screen will return you to this screen.
The following pages describe the CBASE functions shown on the main
selection menu above.
CBASE Version 1.1A Copyright (C) 1985,1986 PC Software Services Page 9
_____________________________________________________________________________
| PC Software Services CBASE 1.1A August 26, 1985 02:05pm |
|___________________________________________________________________________|
Add Records Entry Panel
Customer Number ===> _____(15)______ Date ===> ________(20)________
Last Name ===> _____(15)______ First Name ===> ___(10)___
Company ===> _______________(40)_____________________
Address ===> _______________(40)_____________________
===> _______________(40)_____________________
Business Phone ===> ________(20)________ Home Phone ===> ______(15)_____
Comments ===> ___________________(50)___________________________
Name = ATTN: ===> (1)_
Press "F10"-SAVE "Esc"-LEAVE
___________
________________________________________________________________|__INSERT__|_
| Messages: |
|___________________________________________________________________________|
Data Base : CBASESMP Records : 25 Current Record # : 1
Add Records:
This is the screen you will see when you select option "A" from the main
selection menu. The maximum field lengths are shown in parentheses.
The customer code field will be converted to upper case as it is
entered. The customer code value entered must be unique throughout the
entire data base. If a duplicate customer code is entered, an error
message will be issued and the cursor will be positioned to that field.
This is the only field which must have a value (even if is a blank).
All other fields may be entered in upper or lower case. All fields with
the exception of the "Name = ATTN:" field (which requires a "Y" or "N")
will permit any character to be entered.
See page 6 for keys which may be used during data entry.
When you are ready to add the record, press "F10". The record will be
added and the screen will be ready for another record to add. If you
decide not to add the record, simply press "Esc" and the main selection
menu will be displayed without adding that record.
When you add a record, the customer code is placed into the customer
code index file and a combination of the last and first names will be
added to the customer name index. The zip code is added to zip code
index file. These are used for fast access to records during the Find
function.
CBASE Version 1.1A Copyright (C) 1985,1986 PC Software Services Page 10
Tips For Adding Records:
Although the data base fields are fixed and labeled for you, there is
nothing that says you can't use the fields for different purposes.
For example, the date field is 18 characters. You could use it as
follows:
Date ===> 08/24/72 06/02/84
The first date could be the date you first did business with this
customer and the second date could be the most recent transaction with
the same customer.
For that matter, if you didn't need a date, use the field for something
else..like a nickname.
CBASE can easily be used at home for an address book. You don't have to
put anything in the company name field.
REMEMBER, ANY FIELD CAN HAVE ANY COMBINATION OF CHARACTERS FOR ANY
PURPOSE.
And finally, don't forget about the comments field. You have 50
characters to play with.
CBASE Version 1.1A Copyright (C) 1985,1986 PC Software Services Page 11
_____________________________________________________________________________
| PC Software Services CBASE 1.1A August 26, 1985 02:05pm |
|___________________________________________________________________________|
DOS COMMAND ENTRY PANEL
===> _
Press "F10"-ENTER "Esc"-ABORT
_____________________________________________________________________________
| Messages: |
|___________________________________________________________________________|
Data Base : Records : 0 Current Record # : 1
DOS Commands:
This is the screen you will see when you select option "C" from the main
selection menu. When you see this screen, CBASE will already have saved
the name of the current directory and closed all of the data base files.
When you leave this screen, CBASE will set the directory back the way it
was when you entered. CBASE will also re-open the current data base
files. If there is a problem re-opening the the data base, CBASE will
put you into the data base selection screen. It is still possible to
select the same data base because the data base selection function has
built-in correction (i.e. Rebuild the Index if needed, Restore from a
backup, etc.).
All commands normally entered at a DOS prompt are valid. Since CBASE is
still running while you execute other commands or programs, you may
receive an error message : "Not Enough Memory To Load Program" that you
would not see if you were not running CBASE. It depends on how much
memory your machine has and how much memory the command requires.
CBASE Version 1.1A Copyright (C) 1985,1986 PC Software Services Page 12
_____________________________________________________________________________
| PC Software Services CBASE 1.1A August 26, 1985 02:05pm |
|___________________________________________________________________________|
DATA BASE Entry Panel
Data Base Drive ===> _ (Ex: C)
Data Base Directory ===> _______________(35)________________ (Ex: \PCDBASE\)
Name of Data Base ===> __(8)___ (Ex: BANKCUST)
Bkup Base Drive ===> _ (Ex: B)
Bkup Base Directory ===> _______________(35)________________ (Ex: \PCBKUP\)
Press "F10"-ENTER "Esc"-ABORT
_____________________________________________________________________________
| Messages: |
|___________________________________________________________________________|
Data Base : Records : 0 Current Record # : 1
Select/Create A Data Base:
This is the screen you will see when you select option "D" from the main
selection menu. The maximum field lengths are shown in parentheses.
All Fields will be converted to upper case as they are entered.
The Data Base Drive can be any character from "A" to "Y". Of course if
an attempt is made to create a data base on a non-existent Drive (or for
that matter a non-existent Directory) an error message will be displayed
and you will be prompted to re-enter the values. The character "Z" may
be used for the Backup Data Base Drive to tell CBASE not to create a
backup data base. If you use this option, you will not be able to
backup or restore your data base.
You need not enter anything in the Data Base Directory field if the Data
Base is to be located in the root directory. If you do leave it blank,
a "\" will be filled in for you. If you do specify a directory, it must
begin with a "\". If the directory you enter does not end with a "\"
then one will be added for you.
The Data Base Name can be any name from 1 to 8 characters that does not
contain special characters like . , : ; \, etc. If the Directory or
Data Base Name contains a bad character, the error message will tell you
which position contains the bad character.
CBASE Version 1.1A Copyright (C) 1985,1986 PC Software Services Page 13
_____________________________________________________________________________
| PC Software Services CBASE August 26, 1985 02:05pm |
|___________________________________________________________________________|
FIND Selection Menu
C - Find By Customer Number
N - Find By Customer Name
Z - Find By Zip Code
Esc - Leave FIND Menu
_____________________________________________________________________________
| Messages: |
|___________________________________________________________________________|
Data Base : CBASESMP Records : 25 Current Record # : 1
Find..Edit/Delete A Record:
This is the screen you will see when you select option "F" from the main
selection menu.
This is the main inquiry function of CBASE. A data base record may be
found by customer code or by customer name or by zip code. This screen
asks by which key you wish to search.
Once you have selected the key to search, you will be asked to enter all
or part of that field. For example, if you chose to search by customer
code, you could enter the entire customer code or just the first part of
the customer code. If that customer code is not found, the record with
a customer code nearest and higher to the one you entered will be shown.
If there were no records with a higher customer code, then the next
lowest will be shown.
After pressing "F10" a screen similar to the one on the next page will
be displayed.
CBASE 1.1A Version 1.1A Copyright (C) 1985,1986 PC Software Services Page 14
_____________________________________________________________________________
| PC Software Services CBASE 1.1A August 26, 1985 02:05pm |
|___________________________________________________________________________|
FIND Display Panel
Customer Number ===> 193-28-3988 Date ===> 08/17/85
Last Name ===> Goosenberger First Name ===> George
Company ===> Ducks Unlimited
Address ===> 1423 Swan Drive
===> Turkey Town USA
Business Phone ===> (777) 645-3293 Home Phone ===> (777) 384-7362
Comments ===> Sparrows also available
Name = ATTN: ===> (1)_
"Home"-FIRST "End"-LAST "^"-NEXT "\/"-PREVIOUS
"F2"-EDIT "F3"-DELETE "F4"-PRINT LABEL "F9"-RETURN "Esc"-LEAVE
_____________________________________________________________________________
| Messages: Customer Name Not Found..Next Displayed |
|___________________________________________________________________________|
Data Base : CBASESMP Records : 25 Current Record # : 1
Once you have a record displayed as above, you have many functions
available to you.
"F2" - Will allow modification of the record. (EDIT)
"F3" - Will delete the record. (DELETE)
"F4" - Will print a label or envelope. (PRINT)
"F9" - Will return to the Main Selection Menu.(RETURN)
The following functions are based on which key was used for the search:
"Up Arrow" or "Pg Up" - Display the record with the next highest key.
"Down Arrow" or "Pg Dn" - Display the record with the next lowest key.
"End" - Display the record with the highest key.
"Home" - Display the record with the lowest key.
Examples of the EDIT and DELETE functions are shown on the next two
pages.
CBASE Version 1.1A Copyright (C) 1985,1986 PC Software Services Page 15
_____________________________________________________________________________
| PC Software Services CBASE 1.1A August 26, 1985 02:05pm |
|___________________________________________________________________________|
EDIT Record Entry Panel
Customer Number ===> 193-28-3988_ Date ===> 08/17/85
Last Name ===> Goosenberger First Name ===> George
Company ===> Ducks Unlimited
Address ===> 1423 Swan Drive
===> Turkey Town USA
Business Phone ===> (777) 645-3293 Home Phone ===> (777) 384-7362
Comments ===> Sparrows also available
Name = ATTN: ===> (1)_
Press "F10"-SAVE "Esc"-LEAVE
_____________________________________________________________________________
| Messages: |
|___________________________________________________________________________|
Data Base : CBASESMP Records : 25 Current Record # : 1
EDIT A Record:
This is the screen you will see when you press "F2" from the find
display panel.
Once in this screen, you may change the record as you wish. All keys
that were functional during the Add function will work here. After
making the necessary changes, press "F10" to save the record. If you
you decide not to change the record, press "Esc" and the find display
panel will appear showing the record unchanged.
CBASE Version 1.1A Copyright (C) 1985,1986 PC Software Services Page 16
_____________________________________________________________________________
| PC Software Services CBASE 1.1A August 26, 1985 02:05pm |
|___________________________________________________________________________|
Verify DELETE Panel
Customer Number ===> 193-28-3988
Customer Name ===> GOOSENBERGER GEORGE
Press "Enter"-DELETE "Esc"-LEAVE
_____________________________________________________________________________
| Messages: |
|___________________________________________________________________________|
Data Base : CBASESMP Records : 25 Current Record # : 1
DELETE A Record:
This is the screen you will see when you press "F3" from the find
display panel.
If you press "Enter" the record will be deleted from the data base.
After the record is deleted, the find display panel will appear with the
the next record displayed. If you press "Esc", the find display panel
will appear with the same record displayed.
CBASE Version 1.1A Copyright (C) 1985,1986 PC Software Services Page 17
_____________________________________________________________________________
| PC Software Services CBASE 1.1A August 26, 1985 02:05pm |
|___________________________________________________________________________|
List DEVICE/MEDIA Selection Menu
L - List To Labels
P - List To Paper
S - List To Screen
Esc - Leave DEVICE/MEDIA Menu
_____________________________________________________________________________
| Messages: |
|___________________________________________________________________________|
Data Base : CBASESMP Records : 25 Current Record # : 1
List/Print Data Base:
This is the screen you will see when you select option "L" from the main
selection menu. The List function allows print of the data base to the
screen, printer paper, or printer labels (or envelopes).
The next three pages will show sample output from each of the above
types.
CBASE Version 1.1A Copyright (C) 1985,1986 PC Software Services Page 18
*******************************
*******************************
*******************************
*******************************
*******************************
*******************************
*******************************
*******************************
_____________________________________________________________________________
| PC Software Services CBASE 1.1A August 26, 1985 02:05pm |
|___________________________________________________________________________|
Press "A"-Alignment Labels "Enter"-Begin Print "Esc"-Leave
_____________________________________________________________________________
| Messages: |
|___________________________________________________________________________|
Data Base : CBASESMP Records : 25 Current Record # : 1
List To Labels:
After choosing the Labels option and selecting which key to sort on, two
alignment labels will be printed (as above) followed by a display of the
above screen. "A" will print another alignment label, "Enter" will
start the print of the labels, and "Esc" will return to the previous
menu. Once the labels begin printing you can stop the printing by
pressing "Esc". See page 25 for details on how to define lines per
label and how far to indent per label.
This is an example of what is printed on the label:
George Goosenberger
Ducks Unlimited
1423 Swan Drive
Turkey Town USA
CBASE Version 1.1A Copyright (C) 1985,1986 PC Software Services Page 19
Page 01
Data Base CBASESMP Sorted By Customer Name as of August 02, 1985 11:12am
Customer Number Customer Name Company Name
-------- ------ -------- ---- ------- ----
999-99-9999 Berryball, Benny Strawberry Footballs Inc.
382-05-4827 Buckaroo, Bob Anything For Buck
394-57-3829 Cuttegon, Clyde Opaque Glass Inc.
700-90-4321 DuddleBerry, Doug DuddleBerry's Wine
483-39-1937 Esterhouse, Eric Everything Exciting Inc.
193-28-3988 Goosenberger, George Ducks Unlimited
482-49-4839 Horse, Harry Break Training Inc.
111-11-1112 Hossenberg, Harry Hossenberg Farm Tools
193-48-8374 Nixon, Richard Surplus Tapes Inc.
393-49-2849 Peterbuilt, Peter The House That Peter Built
394-95-1873 Quacker, Quinn Bill Consolidation Inc.
900-76-9876 Slazenger, Sly Slippery Soap Co.
397-48-1927 Underwood, Urney Fallen Timber Surplus
555-55-5555 Williamsworth, Willy Worthless Works Inc.
487-48-6105 Xerox, Rex Duplication Inc.
List To Paper:
After choosing the Paper option and selecting which key to sort on, the
the customer code, customer name, and company name (first 33 characters)
will be printed in a paged format as above. You may stop the printing
at any time by pressing "Esc".
CBASE Version 1.1A Copyright (C) 1985,1986 PC Software Services Page 20
_____________________________________________________________________________
| PC Software Services CBASE 1.1A August 26, 1985 02:05pm |
|___________________________________________________________________________|
Customer Number Customer Name Company Name
-------- ------ -------- ---- ------- ----
> 999-99-9999 Berryball, Benny Strawberry Footballs Inc.
382-05-4827 Buckaroo, Bob Anything For Buck
394-57-3829 Cuttegon, Clyde Opaque Glass Inc.
700-90-4321 DuddleBerry, Doug DuddleBerry's Wine
483-39-1937 Esterhouse, Eric Everything Exciting Inc.
193-28-3988 Goosenberger, George Ducks Unlimited
482-49-4839 Horse, Harry Break Training Inc.
111-11-1112 Hossenberg, Harry Hossenberg Farm Tools
193-48-8374 Nixon, Richard Surplus Tapes Inc.
393-49-2849 Peterbuilt, Peter The House That Peter Built
394-95-1873 Quacker, Quinn Bill Consolidation Inc.
900-76-9876 Slazenger, Sly Slippery Soap Co.
397-48-1927 Underwood, Urney Fallen Timber Surplus
555-55-5555 Williamsworth, Willy Worthless Works Inc.
487-48-6105 Xerox, Rex Duplication Inc.
"F2"-EDIT "F3"-DEL "F4"-LBL "F10"-DIS "\/" "Pg\/" "^" "Pg^" "Home" "End" "Esc"
_____________________________________________________________________________
| Messages: |
|___________________________________________________________________________|
Data Base : CBASESMP Records : 25 Current Record # : 1
List To Screen:
After choosing the Screen option and selecting which key to sort on, the
the customer code, customer name, and company name (first 35 characters)
will be listed to the screen as above.
To move through the data base, use the "Arrow Up", "Arrow Down",
"PgUp", or "PgDn" keys. The ">" on the left-hand side of the screen
is the current record pointer. If this pointer is at the bottom of the
screen and you press "Arrow Down" or "PgDn", then records shown at the
top of the screen will be removed as more records are added to the
bottom. The "Arrow" keys will always move the pointer 1 record. The
"Page" keys will move the pointer a maximum of 16 records. For example,
if the pointer is at the top of the screen and you press "PgDn", you
will see the next page of records. If the pointer is pointing to the
second record on the screen and you press "PgDn", then the second record
will move to the top of the screen. "Home" moves to the top of the data
base and "End" moves to the bottom of the data base. It's a lot easier
to use than it sounds!
Once you are pointing to the record you would like to do something with,
there are several functions available to you:
"F2" - will edit the record for changes you want to make
"F3" - will delete the record
"F4" - will print a label or envelope of the record
"F10"- will display the record and allow any of the above functions
Please see the Find section for a description of these functions.
CBASE Version 1.1A Copyright (C) 1985,1986 PC Software Services Page 21
_____________________________________________________________________________
| PC Software Services CBASE 1.1A August 26, 1985 02:05pm |
|___________________________________________________________________________|
ENVIRONMENT Option Selection Menu
C - Color Options
O - Other Options
P - Printer Options
Esc - Leave Options Menu
_____________________________________________________________________________
| Messages: |
|___________________________________________________________________________|
Data Base : CBASESMP Records : 25 Current Record # : 1
Options:
This is the screen you will see when you select option "O" from the main
selection menu. In each of the option screens, "F10" will save the
supplied options in memory (just for the current execution of CBASE).
After saving, you will be asked to press "Enter" to save into the
parameter file or "Esc" to leave. If you press "Enter" your updates
will be saved for future executions of CBASE. If you press "Esc" your
updates will be in effect for only the current execution of CBASE.
The following pages describe the available options.
CBASE Version 1.1A Copyright (C) 1985,1986 PC Software Services Page 22
_____________________________________________________________________________
| PC Software Services CBASE 1.1A August 26, 1985 02:05pm |
|___________________________________________________________________________|
COLOR Options Entry Panel
Box Outlines ===> 4 Box Inserts ===> 3
Arrows ===> 4 Error Messages ===> G
Display-High ===> F Display-Low ===> 2
Menus-High ===> H Menus-Low ===> 3
Info Line-High ===> 5 Info Line-Low ===> 2
Modify Forgrnd ===> 7 Modify Bakgrnd ===> 1 -|
Header Forgrnd ===> H Header Bakgrnd ===> 4 |--|
Prompt Forgrnd ===> H Prompt Bakgrnd ===> 4 _| |
(COLOR: 0-7, MONO: 0 or 7) <
_0_ _1_ _2_ _3_ _4_ _5_ _6_ _7_ _A_ _B_ _C_ _D_ _E_ _F_ _G_ _H_
### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ###
### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ###
Press "F9"-RETURN "F10"-ENTER "Esc"-LEAVE
_____________________________________________________________________________
| Messages: |
|___________________________________________________________________________|
Data Base : CBASESMP Records : 25 Current Record # : 1
Color Options:
After choosing the Color Options, the above screen will be displayed.
The "###" characters are sample colors to be selected above. For best
results, try to use unique colors for Error Messages and the Modify
fields.
Backlighting The Input Fields:
If you would like the data entry fields to be backlight, do the
following:
Monochrome Screens: Set Modify Background to 7
Set Modify Foreground to 0
Color Screens: Set Modify Background to 1 or 2 or 3 or 4 or 5 or 6 or 7
Set Modify Foreground to something different
CBASE Version 1.1A Copyright (C) 1985,1986 PC Software Services Page 23
_____________________________________________________________________________
| PC Software Services CBASE 1.1A August 26, 1985 02:05pm |
|___________________________________________________________________________|
OPTION Entry Panel
Supply Today's Date On Add Screen ===> Y (Y or N)
Constantly Update Time/Date on Screen ===> Y (Y or N)
Sound Beep With Error Messages ===> Y (Y or N)
Eliminate Snow With IBM Color Card ===> N (Y or N)
(Will Slow Down Non AT Att Screens)
Press "F9"-RETURN "F10"-ENTER "Esc"-LEAVE
_____________________________________________________________________________
| Messages: |
|___________________________________________________________________________|
Data Base : CBASESMP Records : 25 Current Record # : 1
Other Options:
After choosing the Other Options, the above screen will be displayed.
Supply Today's Date On Add Screen:
This is a feature to save you some typing. If the response is Y then
the date field will automatically be filled in with the current date on
the Add screen. The format is MM/DD/YY.
Constantly Update Time/Date on Screen:
Setting this to "N" will update the screen only when a key has been
entered.
Sound Beep With Error Messages:
For those who work in a quiet office, the response would be N.
Eliminate Snow On IBM Color Monitor:
To speed up the process of writing to the screen, CBASE writes directly
to the screen buffer. On PC's with an IBM color board this causes some
snow to appear on the screen during the write operation. If you select
"N" for this option, CBASE will prevent the snow. This method is slower
but the snow will no longer be visible.
CBASE Version 1.1A Copyright (C) 1985,1986 PC Software Services Page 24
_____________________________________________________________________________
| PC Software Services CBASE 1.1A August 26, 1985 02:05pm |
|___________________________________________________________________________|
PRINT OPTION Entry Panel
Number Of Lines Per Page For Print ===> 66 (9 to 99)
Number Of Lines Label To Label Down ===> 06 (6 to 99)
Number Of Spaces To Indent For Labels ===> 02 (6 to 99)
Number Of Labels Across ===> 01 (1 to 4)
Number Of Spaces Label To Label Across ===> 34 (30to 99)
Press "F9"-RETURN "F10"-ENTER "Esc"-LEAVE
_____________________________________________________________________________
| Messages: |
|___________________________________________________________________________|
Data Base : CBASESMP Records : 25 Current Record # : 1
Print Options:
After choosing the Print Options, the above screen will be displayed.
Number Of Lines Per Page For Print:
This should be the number of lines from the top of one page to the top
of the next page.
Number Of Line Label To Label Down:
This should be the number of lines from the top of one label to the top
of the next label.
Number Of Spaces To Indent For Labels:
This should be the number of blanks that should be between the left
margin and where the print should begin on the label. Notice that up to
99 characters is allowed so that envelopes can also be addressed.
Number Of Labels Across:
This is new with release 1.1A of CBASE. This should be the number of
labels across a single row.
Number Of Spaces Label To Label Across:
This should be the number of spaces from the beginning of one label to
to the beginning of the label to the right. This is used only when the
number of labels across is greater than 1.
CBASE Version 1.1A Copyright (C) 1985,1986 PC Software Services Page 25
_____________________________________________________________________________
| PC Software Services CBASE 1.1A August 26, 1985 02:05pm |
|___________________________________________________________________________|
UTILITY Selection Menu
B - Backup Data Base
D - Display Data Base Info
I - Rebuild Index Files
R - Restore Data Base
S - Refresh The Screen
Esc - Leave UTILITY Menu
_____________________________________________________________________________
| Messages: |
|___________________________________________________________________________|
Data Base : CBASESMP Records : 25 Current Record # : 1
Utilities:
This is the screen you will see when you select option "U" from the main
selection menu.
Backup Data Base:
When this option is selected, the data base (NAME.DAT) will be copied to
the backup data base (NAME.BAK) with information about when the backup
took place. The location of the backup data base is determined by what
you specified on the Data Base Selection Function.
CBASE Version 1.1A Copyright (C) 1985,1986 PC Software Services Page 26
_____________________________________________________________________________
| PC Software Services CBASE 1.1A August 26, 1985 02:05pm |
|___________________________________________________________________________|
DATA BASE Information Screen
Data Base Files :
Drive:Dir :A:\
Primary Data : CBASESMP.DAT Open : Y
Cust Code Index : CBASESMP.IXC Open : Y
Cust Name Index : CBASESMP.IXN Open : Y
Zip Code Index : CBASESMP.IXZ Open : Y
Bkup Base File :
Drive:Dir :A:\
Primary Data : CBASESMP.BAK Exist: Y
Record Allocation:
Allocated : 26
Used : 25
# That May Be Added : 65510
Press "ANY KEY" To LEAVE
_____________________________________________________________________________
| Messages: |
|___________________________________________________________________________|
Data Base : CBASESMP Records : 25 Current Record # : 1
Display Data Base Info:
This is the data base information screen. The file names are listed and
there is an indicator of whether or not that file is open.
The record counts are shown below the files. Note that there will
always be one more record allocated than used. This is because one
record is used for data base management. Deleted records are reused
in CBASE so these values should always be close. If you have done a
lot of deletes without subsequent adds, more will be allocated than
used. If this is the case, you can reduce the amount of space used by
the data base by the backup function followed by a restore. Deleted
records are not backed up by CBASE.
Rebuild Index Files:
You should use this function any time you encounter an error in the data
base (such as running out of disk space) after you have corrected the
problem. You can cause an automatic rebuild of the index files by
deleting them. The restore function will also rebuild the index files.
CBASE Version 1.1A Copyright (C) 1985,1986 PC Software Services Page 27
_____________________________________________________________________________
| PC Software Services CBASE 1.1A August 26, 1985 02:05pm |
|___________________________________________________________________________|
Restore Data Base VERIFY Panel
Date Of Last Backup : August 12,1985 02:23pm
Number Of Used Records : 25
Press "Enter"-CONTINUE WITH RESTORE "Esc"-DO NOT RESTORE
_____________________________________________________________________________
| Messages: |
|___________________________________________________________________________|
Data Base : CBASESMP Records : 25 Current Record # : 1
Restore Data Base:
This screen will appear when you select the restore option.
If you press "Enter", the data base will be restored and the index files
will be rebuilt. If you press "Esc", no restore will take place.
Refresh The Screen:
There are certain parts of the screen that are seldom rewritten. If for
some reason CBASE is unable to intercept an error from DOS, the screen
could be distorted. This function will simply rewrite the entire
screen. You can also use this function to see the speed differences
between options Y and N for the Eliminate Snow option.
CBASE Version 1.1A Copyright (C) 1985,1986 PC Software Services Page 28
ERROR RECOVERY
----- --------
Error recovery for the data base is handled differently from other
errors in CBASE. If an error occurs doing anything to the data base, a
screen similar to the one below will appear. Notice that CBASE will not
attempt to recover. This is for two reasons: First, most errors to the
data base will be unrecoverable (i.e. not enough space on disk or read
or write error).. Second, a retry attempt could damage the data base.
If you see this screen, copy the screen to the printer or write down the
information before leaving CBASE. After correcting the problem, ALWAYS
delete the index files before re-executing CBASE. CBASE Version 1.2A
will allow retry for minor problems such as "Disk Drive Not Ready".
_____________________________________________________________________________
| PC Software Services CBASE 1.1A August 26, 1985 02:05pm |
|___________________________________________________________________________|
*** DATA BASE I/O ERROR ***
Interrupt Code = 02 Return Code = 153
Disk drive not ready
File A:\CBASESMP.DAT Record 6
-- DUE TO POSSIBLE DAMAGE TO DATA BASE .. --
RECOVERY WILL NOT BE ATTEMPTED
Press Any Key To ABORT CBASE
_____________________________________________________________________________
| Messages: |
|___________________________________________________________________________|
Data Base : CBASESMP Records : 25 Current Record # : 1
CBASE Version 1.1A Copyright (C) 1985,1986 PC Software Services Page 29
ERROR RECOVERY (Continued)
----- --------
Any error which involves the parameter file or print operations will
allow retry. If an error occurs reading or writing the parameter file,
you will probably receive two error screens (similar to below) in a row.
This is because CBASE receives two interrupts and you should be notified
about both. Simply retry both times after correcting the problem and
all should be well. For parameter file errors and printer errors the
error screen should look similar to below.
_____________________________________________________________________________
| PC Software Services CBASE 1.1A August 26, 1985 02:05pm |
|___________________________________________________________________________|
ERROR Notification/Recovery Screen
Error Writing Parm File
Interrupt 24 Code = 02 IO Result Code = 00
Disk drive not ready
Press "ENTER" To RETRY "Esc" To ABORT
_____________________________________________________________________________
| Messages: |
|___________________________________________________________________________|
Data Base : CBASESMP Records : 25 Current Record # : 1
CBASE Version 1.1A Copyright (C) 1985,1986 PC Software Services Page 30
NOTES FROM THE AUTHOR
----- ---- --- ------
I wrote CBASE with the user in mind. If I was successful, someone who
has never seen CBASE should be able to sit down with it and use it
effectively within ten minutes.
A lot of testing was done with CBASE but I know there will be problems
found by you the users. If you find a problem or have a suggestion
for improvement, please jot it down and send it to us. Problem fixes
and minor improvements will be incorporated into future release levels.
Major enhancements will be in future versions. If find a problem that
prevents you from using CBASE, call us and we will send you a fix as
quickly as possible.
I want to thank you in advance for choosing CBASE and I hope it will
perform to your expectations.
THANK YOU,
Dan Gillingham
Owner- PC Software Services
P.O. Box 22661
Houston, Texas 77227-2661
(713) 931-0507